<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-CN"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta http-equiv="Content-Language" content="zh-CN"><link href="stylesheet.css" media="all" rel="stylesheet" type="text/css">
<title>例子</title>
<script> var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?d286c55b63a3c54a1e43d10d4c203e75"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })(); </script>
</head><body class="SECT1">
<div>
<table summary="Header navigation table" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><th colspan="5" align="center" valign="bottom">PostgreSQL 8.2.3 中文文档</th></tr>
<tr><td width="10%" align="left" valign="top"><a href="gist-implementation.html" accesskey="P">后退</a></td><td width="10%" align="left" valign="top"><a href="gist.html">快退</a></td><td width="60%" align="center" valign="bottom">章50. GiST 索引</td><td width="10%" align="right" valign="top"><a href="gist.html">快进</a></td><td width="10%" align="right" valign="top"><a href="gist-recovery.html" accesskey="N">前进</a></td></tr>
</table>
<hr align="LEFT" width="100%"></div>
<div class="SECT1"><h1 class="SECT1"><a name="GIST-EXAMPLES">50.4. 例子</a></h1>
<p>PostgreSQL 源代码版本包括好几个使用 GiST 实现的索引方法。核心系统目前为某些内置的几何数据类型提供 R-Tree 的等效功能(参阅 <tt class="FILENAME">src/backend/access/gist/gistproc.c</tt>)。下面的 <tt class="FILENAME">contrib</tt> 模块也包含 GiST 操作符类：</p>
<div class="VARIABLELIST">
<dl>
<dt>btree_gist</dt>
<dd><p>好几种类型的 B-Tree 等效</p></dd>
<dt>cube</dt>
<dd><p>用于多维立方体的索引</p></dd>
<dt>intarray</dt>
<dd><p>用于一维 int4 数组值的 RD-Tree</p></dd>
<dt>ltree</dt>
<dd><p>用于树状结构的索引</p></dd>
<dt>pg_trgm</dt>
<dd><p>使用 trigram 匹配的文本相似查找</p></dd>
<dt>seg</dt>
<dd><p>用于"漂浮范围"(float ranges)的索引</p></dd>
<dt>tsearch2</dt>
<dd><p>全文索引</p></dd>
</dl>
</div>
</div>
<div>
<hr align="LEFT" width="100%">
<table summary="Footer navigation table" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="33%" align="left" valign="top"><a href="gist-implementation.html" accesskey="P">后退</a></td><td width="34%" align="center" valign="top"><a href="index.html" accesskey="H">首页</a></td><td width="33%" align="right" valign="top"><a href="gist-recovery.html" accesskey="N">前进</a></td></tr>
<tr><td width="33%" align="left" valign="top">实现</td><td width="34%" align="center" valign="top"><a href="gist.html" accesskey="U">上一级</a></td><td width="33%" align="right" valign="top">崩溃恢复</td></tr>
</table>
</div>
</body></html>